package com.sfac.springboot.modules.test.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.sfac.springboot.aop.MyAnnotation;
import com.sfac.springboot.modules.common.vo.Result;
import com.sfac.springboot.modules.common.vo.Search;
import com.sfac.springboot.modules.test.dao.CityDao;
import com.sfac.springboot.modules.test.dao.CityDaoPlus;
import com.sfac.springboot.modules.test.entity.City;
import com.sfac.springboot.modules.test.service.CityService;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;

/**
 * @author jzq
 * @date 2022/8/18 9:38
 */
@SuppressWarnings({"all"})
@Service
public class CityServiceImpl implements CityService {

    @Autowired
    private CityDao cityDao;

    @Autowired
    private CityDaoPlus cityDaoPlus;


    @Override
    @Transactional
    public Result<City> insertCity(City city) {
        City temp = cityDao.getCityByCityName(city.getCityName());
        if (temp != null) {
            return new Result<>(Result.ResultStatus.FAILED.code,
                    "City name is repead");
        }

        city.setDateCreated(new Date());
        city.setDateModified(new Date());

        // cityDao.insertCity(city);
        cityDaoPlus.insert(city);
        return new Result<>(Result.ResultStatus.SUCCESS.code,
                "Insert success", city);
    }


    @Override
    @Transactional
    public Result<City> updateCity(City city) {
        City temp = cityDao.getCityByCityName(city.getCityName());
        if (temp != null && temp.getCityId() != city.getCityId()) {
            return new Result<>(Result.ResultStatus.FAILED.code,
                    "City name is repead");
        }

        city.setDateModified(new Date());
        // cityDao.updateCity(city);
        UpdateWrapper wrapper = new UpdateWrapper();
        wrapper.eq(true, "city_id", city.getCityId());
        wrapper.set(true, "city_name", city.getCityName());
        wrapper.set(true, "local_city_name", city.getLocalCityName());
        cityDaoPlus.update(city, wrapper);
        return new Result<>(Result.ResultStatus.SUCCESS.code,
                "Update success", city);
    }


    @Override
    @Transactional
    public Result<Object> deleteCityByCityId(int cityId) {
        // cityDao.deleteCityByCityId(cityId);
        Map<String, Object> map = new HashMap<>();
        map.put("city_id", cityId);
        cityDaoPlus.deleteByMap(map);
        return new Result<>(Result.ResultStatus.SUCCESS.code,
                "Delete success");
    }


    @Override
    @MyAnnotation
    public City getCityByCityId(int cityId) {
        // return cityDao.getCityByCityId(cityId);
        return cityDaoPlus.selectById(cityId);
    }


    @Override
    public City getCityByNames(String cityName, String localCityName) {
        return cityDao.getCityByNames(cityName, localCityName);
    }


    @Override
    public List<City> getCitiesByCountryId(int countryId) {
        return Optional.ofNullable(cityDao.getCitiesByCountryId(countryId))
                .orElse(Collections.emptyList());
    }


    @Override
    public PageInfo<City> getCitiesBySearch(Search search) {
        //初始化search对象
        search.init();
        //分页
        PageHelper.startPage(search.getCurrentPage(), search.getPageSize());
        //返回分页对象
        return new PageInfo<>(Optional
                .ofNullable(cityDao.getCitiesBySearch(search))
                .orElse(Collections.emptyList()));
    }


    @Override
    public Page<City> getCitiesBySearch2(Search search) {
        //初始化search
        search.init();

        //构造page对象
        Page<City> page = new Page<>(search.getCurrentPage(), search.getPageSize());

        //构造QueryWrapper对象
        QueryWrapper<City> wrapper = new QueryWrapper<>();
        wrapper.like(StringUtils.isNotBlank(search.getKeyword()),
                        "city_name",
                        search.getKeyword())
                .or()
                .like(StringUtils.isNotBlank(search.getKeyword()),
                        "local_city_name",
                        search.getKeyword());
        wrapper.orderBy(true,
                StringUtils.isBlank(search.getDirection()) || search.getDirection().toLowerCase().equals("asc"),
                search.getSort());

        // 查询
        return cityDaoPlus.selectPage(page, wrapper);

    }

}
